--- CS-009-09
---

Create View ViajesView AS
select V.*, O.T008nombre T005Origen, D.T008nombre T008Destino
from T005 V
inner join T008 O on (V.T008IdOrigen = O.T008IdOrigen)
inner join T008 D on (V.T008IdDestino = D.T008IdOrigen) 

DECLARE @T027IdScript as varchar(80)
DECLARE @T027Descripcion as varchar(360)
SET @T027IdScript='CS-009-09'
SET @T027Descripcion='Se agrega vista ViajesView'
INSERT INTO T027(T027IdScript,T027Descripcion,T027FechaRealizado) VALUES (@T027IdScript,@T027Descripcion,getdate())